from common.opmysql import *

def del_db(env,list,activityId):
    for j in list:
        sql="delete from platform_game.{} where activity_id={};".format(j,activityId)
        OperationDb(env).op_sql(sql)

def update_db(env,tableName,field,value,activityId):
    sql="update platform_game.{} set {} = {} where activity_id = {};".format(tableName,field,value,activityId)
    print("更新活动:",sql)
    OperationDb(env).op_sql(sql)